<%-- 
    Document   : DeferRefill
    Created on : Jun 28, 2012, 11:44:45 PM
    Author     : praneeth
--%>

<%@page import="java.sql.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
<title>DeferRefill</title>
</head>
<body>
<div id="container">
  <div id="header">
        	<h2>E Gas Sewa</span></h2>
			<div id="footer"><h6>Copyright © MIPGS09-12 org</h6></div>
        </div>   
    <div id="menu">

        	<ul>
            	<li class="menuitem"><a href="#">Home</a></li>
                <li class="menuitem"><a href="#">About</a></li>
                <li class="menuitem"><a href="#">Products</a></li>
                <li class="menuitem"><a href="#">Services</a></li>
              <li class="menuitem"><a href="#">Contact</a></li>
			  </ul>
    </div>
        <div id="leftmenu">
    	            <div id="leftmenu_top"></div>
	    		<div id="leftmenu_main"> 
 <h3></h3>				
                <ul>
                    <li><a href="UpdateAcc.jsp">Update Account</a></li>
                    <li><a href="viewstatus.jsp">View Status</a></li>
                    <li><a href="TransferCustomer.jsp">Transfer Account</a></li>
                    <li><a href="SearchDealer.html">Search Dealer</a></li>
                    <li><a href="Cancl.jsp">Cancellation</a></li>
                    <li><a href="NewConnection.jsp">NewConnection</a></li>
                    <li><a href="SearchAccessori.html">Accessories</a></li>
                    <li><a href="#">Notification</a></li>
		</ul>
                </div>              
                   <div id="leftmenu_bottom"></div>
        </div>
	<div id="content">        
        <div id="content_top"></div>
        <div id="content_main">
            <form action="DeferStorage.jsp">
                <table>
                 <% 
       
          try{   
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
               String a=session.getAttribute("userid").toString();
                 String q1="select * from Refill";
       
       
        Connection connection = DriverManager.getConnection("jdbc:odbc:egasdsn");
        Statement stmt =connection.createStatement();       
        ResultSet rs =stmt.executeQuery(q1);
            //while
        if(rs.next()){
                String RefillId=rs.getString(1);
                String Name=rs.getString(2);
                String ConsumerId=rs.getString(3);
                String DealerId=rs.getString(4);
                String pwd=rs.getString(5);
               

%>
         <tr><td><font color="blue"> Refillid:</font><input type="text" name="rid" value="<%= RefillId%>" disabled="true">></input>></td></tr>
         <tr><td><font color ="blue">Name:</font><input type="text" name="cname" value="<%= Name%>" disabled="true">></input>></td></tr>
         <tr><td><font color="blue">ConsumerId:</font><input type="text" name="cid" value="<%= ConsumerId%>" disabled="true">></input></td></tr>
         <tr><td><font color="blue">DealerId:</font><input type="text" name="did" value="<%= DealerId%>" disabled="true"></input>></td></tr>
        <!-- <tr><td><font color="blue">Do you want to refill
		 yes<input type="radio" name="yes" value="" />
         No</font><input type="radio" name="yes" value="" /></td></tr> -->
         <tr><td>
          <font color="blue">Select DeferDate: </font><select name="day">
         <option>1</option><option>2</option><option>3</option><option>4</option><option>5</option>
         <option>6 </option><option>7</option><option>8</option><option>9</option><option>10</option>
         <option>11</option><option>12</option><option>13</option><option>14</option><option>15</option>
         <option>16</option><option>17</option><option>18</option><option>19</option><option>20</option>
         <option>21</option><option>22</option><option>23</option><option>24</option><option>25</option>
         <option>26</option><option>27</option><option>28</option><option>29</option><option>30</option>
         <option>31</option></select>
         <select name="month">
          <option>1</option><option>2</option><option>3</option><option>4</option><option>5</option>
          <option>6</option><option>7</option><option>8</option><option>9</option><option>10</option>
          <option>11</option><option>12</option></select>
           <select name="year" value="2012">
           <option>2012</option></select></td></tr>
           <!--<tr><td><font color="blue">Select Time:</font>
          <select name="time">
         <option>TIME</option><option>7am-10am</option><option>10am-5pm</option><option>5pm-9pm</option>
           </select></td></tr>-->
            <tr><td>
             <input type="SUBMIT" value="Defer"/></td></tr>
         
           
           
           <%               
            }
               
               }catch(Exception e){
        }

    %>
         
         
         
         </table>
    </form>	
        </div>
        <div id="content_bottom"></div> 
            
      </div>
   </div>
</body>
</html>
